| Array | SUMPRODUCT | SUMPRODUCT(array1, [array2, ...]) | Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more |
| Date | TIMESTAMP | TIMESTAMP() | Returns timestamp in seconds |
| Engineering | BIN2DEC | BIN2DEC(signed_binary_number) | Converts a signed binary number to decimal format. Learn more |
| Engineering | BIN2HEX | BIN2HEX(signed_binary_number, [significant_digits]) | Converts a signed binary number to signed hexadecimal format. Learn more |
| Engineering | BIN2OCT | BIN2OCT(signed_binary_number, [significant_digits]) | Converts a signed binary number to signed octal format. Learn more |
| Engineering | DEC2BIN | DEC2BIN(decimal_number, [significant_digits]) | Converts a decimal number to signed binary format. Learn more |
| Engineering | DEC2HEX | DEC2HEX(decimal_number, [significant_digits]) | Converts a decimal number to signed hexadecimal format. Learn more |
| Engineering | DEC2OCT | DEC2OCT(decimal_number, [significant_digits]) | Converts a decimal number to signed octal format. Learn more |
| Engineering | HEX2BIN | HEX2BIN(signed_hexadecimal_number, [significant_digits]) | Converts a signed hexadecimal number to signed binary format. Learn more |
| Engineering | HEX2DEC | HEX2DEC(signed_hexadecimal_number) | Converts a signed hexadecimal number to decimal format. Learn more |
| Engineering | HEX2OCT | HEX2OCT(signed_hexadecimal_number, significant_digits) | Converts a signed hexadecimal number to signed octal format. Learn more |
| Engineering | OCT2BIN | OCT2BIN(signed_octal_number, [significant_digits]) | Converts a signed octal number to signed binary format. Learn more |
| Engineering | OCT2DEC | OCT2DEC(signed_octal_number) | Converts a signed octal number to decimal format. Learn more |
| Engineering | OCT2HEX | OCT2HEX(signed_octal_number, [significant_digits]) | Converts a signed octal number to signed hexadecimal format. Learn more |
| Financial | CUMIPMT | CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning) | Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more |
| Financial | FV | FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning]) | Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more |
| Financial | IPMT | IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) | Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate. Learn more |
| Financial | IRR | IRR(cashflow_amounts, [rate_guess]) | Calculates the internal rate of return on an investment based on a series of periodic cash flows. Learn more |
| Financial | NPER | NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning]) | Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more |
| Financial | NPV | NPV(discount, cashflow1, [cashflow2, ...]) | Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate. Learn more |
| Financial | PMT | PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning]) | Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more |
| Financial | PPMT | PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) | Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate. Learn more |
| Financial | PV | PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning]) | Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more |
| Financial | RATE | RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess]) | Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate. Learn more |
| Financial | XIRR | XIRR(cashflow_amounts, cashflow_dates, [rate_guess]) | Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows. Learn more |
| Financial | XNPV | XNPV(discount, cashflow_amounts, cashflow_dates) | Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate. Learn more |
| Info | ISBLANK | ISBLANK(value) | Checks whether the referenced cell is empty. Learn more |
| Info | ISERR | ISERR(value) | Checks whether a value is an error other than #N/A. Learn more |
| Info | ISERROR | ISERROR(value) | Checks whether a value is an error. Learn more |
| Info | ISLOGICAL | ISLOGICAL(value) | Checks whether a value is TRUE or FALSE. Learn more |
| Info | ISNA | ISNA(value) | Checks whether a value is the error #N/A. Learn more |
| Info | ISNONTEXT | ISNONTEXT(value) | Checks whether a value is non-textual. Learn more |
| Info | ISNUMBER | ISNUMBER(value) | Checks whether a value is a number. Learn more |
| Info | ISTEXT | ISTEXT(value) | Checks whether a value is text. Learn more |
| Info | NA | NA() | Returns the value not available error, #N/A. Learn more |
| Logical | AND | AND(logical_expression1, [logical_expression2, ...]) | Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. Learn more |
| Logical | FALSE | FALSE() | Returns the logical value FALSE. Learn more |
| Logical | IF | IF(logical_expression, value_if_true, value_if_false) | Returns one value if a logical expression is TRUE and another if it is FALSE. Learn more |
| Logical | IFERROR | IFERROR(value, [value_if_error]) | Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent. Learn more |
| Logical | IFNA | IFNA(value, value_if_na) | Evaluates a value. If the value is an #N/A error, returns the specified value. Learn more. |
| Logical | IFS | IFS(condition1, value1, [condition2, value2], …) | Evaluates multiple conditions and returns a value that corresponds to the first true condition. Learn more. |
| Logical | NOT | NOT(logical_expression) | Returns the opposite of a logical value - NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE. Learn more |
| Logical | OR | OR(logical_expression1, [logical_expression2, ...]) | Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. Learn more |
| Logical | SWITCH | SWITCH(expression, case1, value1, [default or case2, value2], …) | Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met. Learn more |
| Logical | TRUE | TRUE() | Returns the logical value TRUE. Learn more |
| Logical | XOR | XOR(logical_expression1, [logical_expression2, ...]) | The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise. Learn more. |
| Lookup | ADDRESS | ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet]) | Returns a cell reference as a string. Learn more |
| Lookup | COLUMN | COLUMN([cell_reference]) | Returns the column number of a specified cell, with A=1. Learn more |
| Lookup | HLOOKUP | HLOOKUP(search_key, range, index, [is_sorted]) | Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found. Learn more |
| Lookup | INDEX | INDEX(reference, [row], [column]) | Returns the content of a cell, specified by row and column offset. Learn more |
| Lookup | LOOKUP | `LOOKUP(search_key, search_range | search_result_array, [result_range])` |
| Lookup | MATCH | MATCH(search_key, range, [search_type]) | Returns the relative position of an item in a range that matches a specified value. Learn more |
| Lookup | ROW | ROW([cell_reference]) | Returns the row number of a specified cell. Learn more |
| Lookup | VLOOKUP | VLOOKUP(search_key, range, index, [is_sorted]) | Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found. Learn more |
| Math | ABS | ABS(value) | Returns the absolute value of a number. Learn more |
| Math | ACOS | ACOS(value) | Returns the inverse cosine of a value, in radians. Learn more |
| Math | ACOSH | ACOSH(value) | Returns the inverse hyperbolic cosine of a number. Learn more |
| Math | ACOT | ACOT(value) | Returns the inverse cotangent of a value, in radians. Learn more. |
| Math | ACOTH | ACOTH(value) | Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive. Learn more. |
| Math | ASIN | ASIN(value) | Returns the inverse sine of a value, in radians. Learn more |
| Math | ASINH | ASINH(value) | Returns the inverse hyperbolic sine of a number. Learn more |
| Math | ATAN | ATAN(value) | Returns the inverse tangent of a value, in radians. Learn more |
| Math | ATAN2 | ATAN2(x, y) | Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (x,y), in radians. Learn more |
| Math | ATANH | ATANH(value) | Returns the inverse hyperbolic tangent of a number. Learn more |
| Math | CEILING | CEILING(value, [factor]) | Rounds a number up to the nearest integer multiple of specified significance. Learn more |
| Math | CEILING.MATH | CEILING.MATH(number, [significance], [mode]) | Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more. |
| Math | CEILING.PRECISE | CEILING.PRECISE(number, [significance]) | Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up. Learn more. |
| Math | COS | COS(angle) | Returns the cosine of an angle provided in radians. Learn more |
| Math | COSH | COSH(value) | Returns the hyperbolic cosine of any real number. Learn more |
| Math | COT | COT(angle) | Cotangent of an angle provided in radians. Learn more. |
| Math | COTH | COTH(value) | Returns the hyperbolic cotangent of any real number. Learn more. |
| Math | COUNTBLANK | COUNTBLANK(range) | Returns the number of empty cells in a given range. Learn more |
| Math | COUNTIF | COUNTIF(range, criterion) | Returns a conditional count across a range. Learn more |
| Math | CSC | CSC(angle) | Returns the cosecant of an angle provided in radians. Learn more. |
| Math | CSCH | CSCH(value) | The CSCH function returns the hyperbolic cosecant of any real number. Learn more. |
| Math | DECIMAL | DECIMAL(value, base) | The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal). Learn more. |
| Math | DEGREES | DEGREES(angle) | Converts an angle value in radians to degrees. Learn more |
| Math | EVEN | EVEN(value) | Rounds a number up to the nearest even integer. Learn more |
| Math | EXP | EXP(exponent) | Returns Euler's number, e (~2.718) raised to a power. Learn more |
| Math | FACT | FACT(value) | Returns the factorial of a number. Learn more |
| Math | FACTDOUBLE | FACTDOUBLE(value) | Returns the "double factorial" of a number. Learn more |
| Math | FLOOR | FLOOR(value, [factor]) | Rounds a number down to the nearest integer multiple of specified significance. Learn more |
| Math | FLOOR.MATH | FLOOR.MATH(number, [significance], [mode]) | Rounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode. Learn more. |
| Math | FLOOR.PRECISE | FLOOR.PRECISE(number, [significance]) | The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance. Learn more. |
| Math | GCD | GCD(value1, value2) | Returns the greatest common divisor of one or more integers. Learn more |
| Math | INT | INT(value) | Rounds a number down to the nearest integer that is less than or equal to it. Learn more |
| Math | ISEVEN | ISEVEN(value) | Checks whether the provided value is even. Learn more |
| Math | ISO.CEILING | ISO.CEILING(number, [significance]) | See CEILING.PRECISE |
| Math | ISODD | ISODD(value) | Checks whether the provided value is odd. Learn more |
| Math | LCM | LCM(value1, value2) | Returns the least common multiple of one or more integers. Learn more |
| Math | LN | LN(value) | Returns the the logarithm of a number, base e (Euler's number). Learn more |
| Math | LOG | LOG(value, base) | Returns the the logarithm of a number given a base. Learn more |
| Math | LOG10 | LOG10(value) | Returns the the logarithm of a number, base 10. Learn more |
| Math | MOD | MOD(dividend, divisor) | Returns the result of the modulo operator, the remainder after a division operation. Learn more |
| Math | MROUND | MROUND(value, factor) | Rounds one number to the nearest integer multiple of another. Learn more |
| Math | ODD | ODD(value) | Rounds a number up to the nearest odd integer. Learn more |
| Math | PI | PI() | Returns the value of Pi to 14 decimal places. Learn more |
| Math | POWER | POWER(base, exponent) | Returns a number raised to a power. Learn more |
| Math | PRODUCT | PRODUCT(factor1, [factor2, ...]) | Returns the result of multiplying a series of numbers together. Learn more |
| Math | RADIANS | RADIANS(angle) | Converts an angle value in degrees to radians. Learn more |
| Math | RAND | RAND() | Returns a random number between 0 inclusive and 1 exclusive. Learn more |
| Math | RANDBETWEEN | RANDBETWEEN(low, high) | Returns a uniformly random integer between two values, inclusive. Learn more |
| Math | ROUND | ROUND(value, [places]) | Rounds a number to a certain number of decimal places according to standard rules. Learn more |
| Math | ROUNDDOWN | ROUNDDOWN(value, [places]) | Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. Learn more |
| Math | ROUNDUP | ROUNDUP(value, [places]) | Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn more |
| Math | SEC | SEC(angle) | The SEC function returns the secant of an angle, measured in radians. Learn more. |
| Math | SECH | SECH(value) | The SECH function returns the hyperbolic secant of an angle. Learn more |
| Math | SIGN | SIGN(value) | Given an input number, returns -1 if it is negative, 1 if positive, and 0 if it is zero. Learn more |
| Math | SIN | SIN(angle) | Returns the sine of an angle provided in radians. Learn more |
| Math | SINH | SINH(value) | Returns the hyperbolic sine of any real number. Learn more |
| Math | SQRT | SQRT(value) | Returns the positive square root of a positive number. Learn more |
| Math | SQRTPI | SQRTPI(value) | Returns the positive square root of the product of Pi and the given positive number. Learn more |
| Math | SUM | SUM(value1, [value2, ...]) | Returns the sum of a series of numbers and/or cells. Learn more |
| Math | SUMIF | SUMIF(range, criterion, [sum_range]) | Returns a conditional sum across a range. Learn more |
| Math | TAN | TAN(angle) | Returns the tangent of an angle provided in radians. Learn more |
| Math | TANH | TANH(value) | Returns the hyperbolic tangent of any real number. Learn more |
| Math | TRUNC | TRUNC(value, [places]) | Truncates a number to a certain number of significant digits by omitting less significant digits. Learn more |
| Operator | CONCAT | CONCAT(value1, value2) | Returns the concatenation of two values. Equivalent to the & operator. Learn more |
| Statistical | AVERAGE | AVERAGE(value1, [value2, ...]) | Returns the numerical average value in a dataset, ignoring text. Learn more |
| Statistical | AVERAGEA | AVERAGEA(value1, [value2, ...]) | Returns the numerical average value in a dataset. Learn more |
| Statistical | AVERAGEIF | AVERAGEIF(criteria_range, criterion, [average_range]) | Returns the average of a range depending on criteria. Learn more |
| Statistical | CORREL | CORREL(data_y, data_x) | Calculates r, the Pearson product-moment correlation coefficient of a dataset. Learn more |
| Statistical | COUNT | COUNT(value1, [value2, ...]) | Returns a count of the number of numeric values in a dataset. Learn more |
| Statistical | COUNTA | COUNTA(value1, [value2, ...]) | Returns a count of the number of values in a dataset. Learn more |
| Statistical | FORECAST | FORECAST(x, data_y, data_x) | Calculates the expected y-value for a specified x based on a linear regression of a dataset. Learn more |
| Statistical | FORECAST.LINEAR | FORECAST.LINEAR(x, data_y, data_x) | See FORECAST |
| Statistical | LARGE | LARGE(data, n) | Returns the nth largest element from a data set, where n is user-defined. Learn more |
| Statistical | MAX | MAX(value1, [value2, ...]) | Returns the maximum value in a numeric dataset. Learn more |
| Statistical | MAXA | MAXA(value1, value2) | Returns the maximum numeric value in a dataset. Learn more |
| Statistical | MEDIAN | MEDIAN(value1, [value2, ...]) | Returns the median value in a numeric dataset. Learn more |
| Statistical | MIN | MIN(value1, [value2, ...]) | Returns the minimum value in a numeric dataset. Learn more |
| Statistical | MINA | MINA(value1, value2) | Returns the minimum numeric value in a dataset. Learn more |
| Statistical | SLOPE | SLOPE(data_y, data_x) | Calculates the slope of the line resulting from linear regression of a dataset. Learn more |
| Statistical | SMALL | SMALL(data, n) | Returns the nth smallest element from a data set, where n is user-defined. Learn more |
| Statistical | STDEV | STDEV(value1, [value2, ...]) | Calculates the standard deviation based on a sample. Learn more |
| Statistical | STDEV.P | STDEV.P(value1, [value2, ...]) | See STDEVP |
| Statistical | STDEV.S | STDEV.S(value1, [value2, ...]) | See STDEV |
| Statistical | STDEVA | STDEVA(value1, value2) | Calculates the standard deviation based on a sample, setting text to the value 0. Learn more |
| Statistical | STDEVP | STDEVP(value1, value2) | Calculates the standard deviation based on an entire population. Learn more |
| Statistical | STDEVPA | STDEVPA(value1, value2) | Calculates the standard deviation based on an entire population, setting text to the value 0. Learn more |
| Statistical | VAR | VAR(value1, [value2, ...]) | Calculates the variance based on a sample. Learn more |
| Statistical | VAR.P | VAR.P(value1, [value2, ...]) | See VARP |
| Statistical | VAR.S | VAR.S(value1, [value2, ...]) | See VAR |
| Statistical | VARA | VARA(value1, value2) | Calculates an estimate of variance based on a sample, setting text to the value 0. Learn more |
| Statistical | VARP | VARP(value1, value2) | Calculates the variance based on an entire population. Learn more |
| Statistical | VARPA | VARPA(value1, value2,...) | Calculates the variance based on an entire population, setting text to the value 0. Learn more |
| Text | ARABIC | ARABIC(roman_numeral) | Computes the value of a Roman numeral. Learn more |
| Text | CONCATENATE | CONCATENATE(string1, [string2, ...]) | Appends strings to one another. Learn more |
| Text | FIND | FIND(search_for, text_to_search, [starting_at]) | Returns the position at which a string is first found within text. Learn more |
| Text | LEFT | LEFT(string, [number_of_characters]) | Returns a substring from the beginning of a specified string. Learn more |
| Text | LEN | LEN(text) | Returns the length of a string. Learn more |
| Text | LOWER | LOWER(text) | Converts a specified string to lowercase. Learn more |
| Text | MID | MID(string, starting_at, extract_length) | Returns a segment of a string. Learn more |
| Text | REPLACE | REPLACE(text, position, length, new_text) | Replaces part of a text string with a different text string. Learn more |
| Text | RIGHT | RIGHT(string, [number_of_characters]) | Returns a substring from the end of a specified string. Learn more |
| Text | ROMAN | ROMAN(number, [rule_relaxation]) | Formats a number in Roman numerals. Learn more |
| Text | SEARCH | SEARCH(search_for, text_to_search, [starting_at]) | Returns the position at which a string is first found within text. Learn more |
| Text | TRIM | TRIM(text) | Removes leading and trailing spaces in a specified string. Learn more |
| Text | UPPER | UPPER(text) | Converts a specified string to uppercase. Learn more |
